
Solution#: 2  MANY TO MANY RELATIONSHIP MISSING AFTER SAVE AS 3.5.2


A many to many relationship created in ERwin 4.0 and subsequently saved
as a 3.5.2 model will lose the relationship on the physical side of the
ERwin 3.5.2 model.

In order to preserve the relationship when saving as ERwin 3.5.2, the
relationship needs to be transformed prior to saving.  This can be
performed by manually transforming the relationship or by an option in
the Model Properties dialog.  The option for Model Properties is on the
General tab, select the Many to Many Relationships with Association
Table checkbox under Auto Transform Logical Objects.









Solution#: 3  REVERSE ENGINEER NOT GETTING NAMES OF FOREIGN KEY INDEXES


ERwin renames FK indexes that the user has created when Reverse Engineering
from database

the foreign-key constraint clause does not create an index in Oracle.
The index you see in ERwin is there because ERwin shows one for each
relationship that is in the model.

The constraint name is brought back on the Relationship and if you view with
the relationship editor you will see the name.

If you forward engineer the model after RE (make sure the Constraint Names
check box is checked in other options) you will see that the generated SQL
matches the original and that there are no indexes generated for the foreign
keys.











Solution#: 31  HOTLINKS NOT EXPANDING FOR GROUPED OBJECTS


In the Reports, if an RTB is exported to HTML, for the grouped objects,
hotlinks are not expanding.

Available in ERwin 4.0 Service Pack 1








Solution#: 32  SELECTING SYNONYM LEAVES DATABASE/COMMENT FIELDS PROTECTED


WinNT 4.0 SP6A
Once a table synonym is selected, the synonym toggle remains on and the
Database and Comment windows remain protected.

Available in ERwin 4.0 Service Pack 1








Solution#: 33  FOREIGN KEYS NOT GENERATED AFTER REVERSE ENGINEER


Foreign keys are not generated for Sybase 11 even when this schema box
is checked: Referential Integrity: Foreign Key: Alter/FK. The keys are
displayed in the reverse-engineered model.

THis does not appear to be database specific

Available in ERwin 4.0 Service Pack 1








Solution#: 34  HISTORY NOT DISPLAYED PROPERLY IN ATTRIBUTE EDITOR


History in the attribute editor does not show up for an attribute when the
history tab is first clicked until another attribute is clicked in the
attribute editor

History for a prior attribute is displayed if there is no history for the
current selected attribute.

Available in ERwin 4.0 Service Pack 1








Solution#: 35  SYNC OF MODEL NOT DETECTING CHANGE OF ATTRIBUTE DATATYPE


ERwin 4.0 beta question. Create logical model with 1 entity and some
attributes.  Derive physical model.  Then change logical datatype.
Then sync physical with logical.  Datatype will not sync.
However, if you add an attribute this will appear in physical model.
Sync Utility is having problems modifying existing columns.

Available in ERwin 4.0 Service Pack 1








Solution#: 36  CC DB2 UDB CHANGE TO PRIMARY KEY GENERATED INCORRECT DDL


When 2 UDB 6.1 models are compared, and the deltacontains a change to a
primary key, the change DDLthat is generated as a result of of the compare
includesa drop statement but not the recreate statement for the primary key.

Available in ERwin 4.0 Service Pack 1








Solution#: 37  PERFORMANCE ISSUE WITH MANY DOMAINS


ERwin Beta1 performance issues with models containing many domains.
Symptoms include slow model splitting and closing of domain editor.

Available in ERwin 4.0 Service Pack 1








Solution#: 38  ADDING PREFIX ON DERIVE MODEL AFFECTS SOURCE MODEL


If you derive a model and enter a prefix in the Logical to Physical
Conversion window, the change also affects the source model.

Available in ERwin 4.0 Service Pack 1








Solution#: 39  DB2/390 COMPLETE COMPARE SHOWING INCORRECT DIFFERENCES


For a DB2/390v5 design, CC is reporting very strange differences when none of
this nature exist.

Available in ERwin 4.0 Service Pack 1








Solution#: 40 SQL SERVER CREATE TABLE COLUMN DEFAULTS TAGGED AS BOUND


Reverse engineering from SQL Server 7.0 script, CREATE TABLE statements
including column level defaults are mistakenly interpreted as bound
defaults

Available in ERwin 4.0 Service Pack 1








Solution#: 41  EXPORT OF COLUMN LEVEL CHK CONSTAINTS DOES NOT GENERATE SQL


 After changing the definition of a column level check constraint in the
 model, Complete compare against original design does not generate a
 ALTER TABLE DROP Ýcheck¨ CONSTRAINT + ALTER TABLE ADD Ýcheck¨ CONSTRAINT
 but nothing is generated.

 Available in ERwin 4.0 Service Pack 1








Solution#: 43  ALLOW DB2 ALTERNATE CATALOG SELECTION


Allow specification of DB2/390 Alternate Catalog for Reverse Engineering
and Complete Compare functions.  Specification can be made in one of three
places:

   Creation of model dialog
   Selection of Target Database dialog
   Database Connection dialog

Available in ERwin 4.0 Service Pack 1








Solution#: 44  SQL SERVER 7 DEFAULT LIST INCORRECT


For a new SQL Server 7 design, ERwin nicely populates a bunch of
 pre-defined Defaults in my design.  'System_User' is a valid Default, not
 included.  Also, System_Generated and Current_Sqlid may not be valid for
 SQL Server.

Available in ERwin 4.0 Service Pack 1








Solution#: 45  ERWIN HANGS ON MODEL CLOSE


I have a large model (750) entities.  Open with 4,0 beta2 converts from 3.5.2
 format.   Do file save as to new name - save takes 32.39 seconds.  Close
 model by hitting x in top right corner of (model)window (not ERwin's main
 window).  Model appears to close instantly as picture disappears, but ERwin
 remains in wait state with CPU running at 100% (task manager).  Task manager
 also reports after 2 mins 30 sec cpu still at 100% and task is not
 responding.  Killed process with task manager.  Model had just been saved so
 should have closed no problem.

Available in ERwin 4.0 Service Pack 1








Solution#: 46  DB2/UDB6 AUTH-IDS NOT QUALIFYING INDEXES PROPERLY


Erwin suppresses the owner when the owner of index and the table
are same

Available in ERwin 4.0 Service Pack 1








Solution#: 47  COPY/PASTE OF ENTITY LOSES UDP VALUES


copying an entity from one logical model to another loses the values of
 udps.

Fixed in build 1298 (GA)

Available in ERwin 4.0 Service Pack 1








Solution#: 48  DB2/UDB COMPLETE COMPARE OF OBJECTS SHOW INCORRECT VALUES


Internal Erwin parameters appear in the change control manager after running C
Complete Compare.
Column Null Option with value 1.
Index Generate with value 1.
Index columns are positioned 1, 2, ... <n>, while the table columns are
       0, 1, ... <n-1>.
All indexes show as 'cluster'.  Only one index per table is clustered.

Index Generate with value  2.
View With Check:5.
View With Check: 12255237.
Domain Null Option: 0.

Available in ERwin 4.0 Service Pack 1








Solution#: 49 SUPPORT FOR REPLICATED DIMENSIONS


Erwin does not support replicated dimensions.

Support the REPLICATED and NOT LOGGED INITIALLY options for summary tables.

Available in ERwin 4.0 Service Pack 1








Solution#: 50  RTB SELECT ONLY FILTER NOT WORKING PROPERLY


In trying to create an RTF report (using Report Builder) for an entity,
 I apply the 'selected only filter to the entity', which is the top level
 object in the report. From the properties tree I choose filter--selected
 only,entity name and definition. I then add relationships and their
 defintions(parent and child) and finally add the attribute section with
 attriobute nameand attribute defintion.  I expect that the report produced
 will limit the relationships and attibute information only to those that
 pertain the the selected entity.

 It does not work that way.  I get the single entity and its definition,
 but all relationships and all attibutes that are in the model.

 I cannot get the relatinship and attribute information for only the selected
 entity.

Available in ERwin 4.0 Service Pack 1








Solution#: 51  DB2 ASCENDING INDEX COLUMNS NOT RECOGNIZED PROPERLY


For a 390 v5 design, either Complete Compare or catalog capture is
not properly processing Ascending index columns.

Available in ERwin 4.0 Service Pack 1








Solution#: 53  CC DB/2 DIFFERENCES FOR INDEX CLUSTERING LISTED TWICE


For a 390v5 design, Complete Compare is listing index clustering
 differences twice.

Available in ERwin 4.0 Service Pack 1








Solution#: 54  SQL SERVER 7 CHANGE SCRIPT INCORRECT FOR CHANGE IN DEFAULT


 For a SQL SVR 7 design, when I change the value of a Default
 object,the change script does not seem correct.  It should create
 an sp_unbinddefault followed by sp_binddefault.

Available in ERwin 4.0 Service Pack 1








Solution#: 55  UNABLE TO INVOKE COLUMN EDITOR IN PHYSICAL MODEL AFTER OPEN


Open a model and immediately try to go to model|Columns.  Nothing happens.

Available in ERwin 4.0 Service Pack 1








Solution#: 56  INCORRECT COL ORDER EXPORTING CHANGES


Exporting changes using CC and he is getting incorrect column order
and other options.

Available in ERwin 4.0 Service Pack 1








Solution#: 57  COMPLETE COMPARE NOT MATCHING VALIDATION RULE NAME PROPERLY


Logical and Physical Validation Rules are not related.  Complete compare
seems to compare the logical name with the rule name from database.

Available in ERwin 4.0 Service Pack 1








Solution#: 58  UNABLE TO GENERATE DEFINE NO FOR DB2 TABLESPACE


For a 390v6 design, I am unable to get ERwin to generate to script a
 tablespace-level DEFINE NO for a tablespace

Available in ERwin 4.0 Service Pack 1








Solution#: 59  UNABLE TO GENERATE LOG NO FOR DB2 TABLESPACE


For a 390v6 design, I am unable to get ERwin to generate to script a
 tablespace-level LOG NO for a LOB tablespace.

Available in ERwin 4.0 Service Pack 1








Solution#: 60  UNABLE TO GENERATE TRACKMOD NO FOR DB2 TABLESPACE


For a 390v6 design, I am unable to get ERwin to generate to script a
 tablespace-level TRACKMOD NO.

Available in ERwin 4.0 Service Pack 1








Solution#: 61  FE FOR DB2 UDB GENERATES INCORRECT PAGE SIZE STATEMENT


PAGESIZE parameter for DB2/UDB is being generated as PAGE SIZE.  It should
be one word.

Available in ERwin 4.0 Service Pack 1








Solution#: 62  CC REPORTS DIFFERENCE FOR DB2 SUBPAGE ON TYPE 2 INDEX


For a 390v5 design, Complete Compare is reporting 'different'
SUBPAGE values for TYPE 2 indexes even though that parmater is only valid for
a TYPE 1 index.

Available in ERwin 4.0 Service Pack 1








Solution#: 64  DB2/390 FE TO SCRIPT CREATES OBJECTS IN WRONG ORDER


For a 390v5 design, catalog capture followed by forward engineering
to script gives a script whose superior objects do not always preceed the
subordinate objects.   This will bomb when presented to DB2.

Available in ERwin 4.0 Service Pack 1








Solution#: 65  CUSTOMIZED GLOBAL RI TRIGGER DISAPPEARS WHEN ATTACHED


User has customized global level RI triggers.  One of those disappears when
it is clicked to be attached.

Available in ERwin 4.0 Service Pack 1








Solution#: 66  %TABLENAME MACRO NOT EXPANDING IF NO SPACE BEFORE END QUOTE


The macro %TableName, if used within a single or double quotes was working
fine in 3.5.2.  In 4.0, the same macro needs to have a space before the end
quotes for it to work.  This will be problematic for 3.5.2 diagrams opening
in 4.0 if they are using this macro inside the quotes.

Available in ERwin 4.0 Service Pack 1








Solution#: 67  MACROS NOT EXPANDING IN STORED PROCEDURES/TRIGGERS


Erwin macros used in SP in 3.5.2 are not expanding in 4.0

The Stored Procedure using different Erwin macros expanded correctly in 3.5.2
 but are not expanding in 4.0.

Macros are also not expanding properly in Triggers.

Available in ERwin 4.0 Service Pack 1








Solution#: 68  %TABLEPROP MACRO NOT EXPANDING


Property macros such as %Tableprop and %Attprop will not expand.  UDP
values are not being reteieved.

When used in a Global Script or User Defined Trigger the following does not
expand.  %ForEachEntity(){%If(%==(%TableProp(User Notification),Y)){macro
code}  The above statement expands the macro code in ERwin version 3.5.2 for
each entity where the User Defined Property User Notification is equal to the

value Y.  It does not expand in ERwin version 4.0.  The same thing happens
for a table script.  %If(%==(%TableProp(User Notification),Y)){macro code}
The above statement expands the macro code in ERwin version 3.5.2 when
attached to a table where the User Defined Property is equal to Y.  It does
not expand in ERwin version 4.0.

Available in ERwin 4.0 Service Pack 1








Solution#: 69  DB2/UDB6 INCORRECT SYNTAX FOR CREATE NODEGROUP


For a UDB v6 design, forward engineering seems not to be generating
proper syntax for a CREATE NODEGROUP ON NODES phrase.

Syntax IS: CREATE NODEGROUP N01 ON NODES 1 TO 6, 7 TO 15, 999;
Should BE: CREATE NODEGROUP N01 ON NODES (1 TO 6, 7 TO 15, 999);

Available in ERwin 4.0 Service Pack 1








Solution#: 70  RE PARSE ERROR ON CLOB/SBCS DATA OR FOR MIXED DATA PHRASE


Unable to parse CLOB with SBCS DATA or for Mixed DATA Phrase

Available in ERwin 4.0 Service Pack 1








Solution#: 71  %RELPHYSPROP MACRO NOT EXPANDING PROPERLY


Macro (%RelPhysProp(FKrltn),N)) not expanding correctly in 4.0 - is working
fine in 3.5.2.

Available in ERwin 4.0 Service Pack 1








Solution#: 72  PHYSICAL PROPERTIES LOST ON SPLIT MODEL


When the model is splitted, the physical properties assigned to tables and
indexes are lost.  So are the generation options setup for forward
engineering

Available in ERwin 4.0 Service Pack 1








Solution#: 73  RE PARSE ERROR ON ERWIN 3.5.2 GENERATED SCRIPT


For a SQL Svr 7 script produced by ERwin 352sp3, reverse engineering
with v4 is yielding a parser error.

Available in ERwin 4.0 Service Pack 1








Solution#: 75  SQL SERVER 7 FE - DATATYPE SHOWN INSTEAD OF DOMAIN


When preview in FE, the datatype is showing different in 4.0 that it did
for 3.5.2 when domains are used.  Rather than showing the domain name, the
actual datatype is shown for SQL Server 7.

Available in ERwin 4.0 Service Pack 1








Solution#: 76  IDENTITY VALUE MODIFIED ON CONVERSION FROM 3.5.2


When convert a sql server 7 model from 3.5.2, the identity value that was
blank in the 3.5.2 model is populated with the default datatype.  (Default
datatype from Choose DB).
The client found this problem when the datatype was int.

Available in ERwin 4.0 Service Pack 1








Solution#: 77  COLUMN ORDER DIFFERS AFTER REVERSE ENGINEER


Column order after Reverse engineer from script or database does not match
when performing complete compare.

Available in ERwin 4.0 Service Pack 1








Solution#: 78  DOMAIN MIGRATION NOT WORKING PROPERLY


With an identifying relationship, changing the domain of the parent
attributes will not update the domain and datatype of the child attributes
that were migrated.

Available in ERwin 4.0 Service Pack 1








Solution#: 79  CC OF STORED PROCS FOR SQL SERVER 7 NOT RECOGNIZING ALL


Complete Compare stored procedures against Sql Server database does not
recognize all of the procedure code.

Available in ERwin 4.0 Service Pack 1








Solution#: 80  CONVERTING 3.5.2 MODEL TO 4.0 CHANGES DATATYPES OF DOMAINS


When converting from a Erwin 3.5.2 model to 4.0 erwin maps the Physical
datatype Number of the domain Number to the logical datatype Money of the
domain Number.

Available in ERwin 4.0 Service Pack 1








Solution#: 81  PREFIX DUPLICATED ON DERIVE MODEL


If you derive a model and put a prefix in for the table or column names the
prefix gets duplicated.

Available in ERwin 4.0 Service Pack 1








Solution#: 82  UNABLE TO CHANGE COLUMN ORDER WHEN IN PHYSICAL ORDER DISPLAY


Client has a model in ERwin 4.0. and cannot change the column order on the
physical side.(display level is physical order).
Problems with columns occurs when RE from SQL Server 2000, the columns are
out of order and can't be changed.
Also, problems when convert model from 3.5.2 to 4.0.  PK becomes second
column.

Available in ERwin 4.0 Service Pack 1








Solution#: 83  UNABLE TO DELETE COLUMN FROM DB AFTER COMPLETE COMPARE


Used to alter db, now goes thru complete compare.  When cc, there is
a column that she deleted from the model, and when she tries to delete from
the db, DELETE is not enabled.  (db = sql server 2000).
Also, when keep going back within cc, will see multiple tables in the resolve
differences screen.

Available in ERwin 4.0 Service Pack 1








Solution#: 84  COLUMN ORDER CHANGES CONVERTING 3.5.2 MODEL TO 4.0


Problem with Column Order when opening a 3.5.2 model.   Found that it is
pulling in the physical order, not the column order from 3.5.2.
It seems that the 4.0 open translation, uses the physical view, from display
level in 3.5.2.  It seems that the logical and physical views in
4.0, but even that is not consistant.  Sometimes it reverses column order and
sometimes it only reverses the keys, especially with multiple primary keys.

Available in ERwin 4.0 Service Pack 1








Solution#: 86  SQL SERVER 7 STATISTICAL INDEXES SHOWN BY CC AND RE


Problem with Indexes that start with _wa_sys always show up in Complete
Compare.  He is creating constraints in a SQL Server 2000 Database and
Reverse Engineering the database.  When he Complete Compare's he can not
get rid of these indexes.

The indexes are also brought in by Reverse Engineer.  These are statistical
indexes and should not be considered part of the model.

Available in ERwin 4.0 Service Pack 1








Solution#: 87  RE FROM ORACLE 8 NOT RETURNING NUMBER DATA TYPE TABLE PARTS


Re from Oracle 8 does not bring table partition, number datatype.

Available in ERwin 4.0 Service Pack 1








Solution#: 88  SYNC W/MODEL SOURCE SHOWS DIFFERENCES WHEN NO CHANGES


Model source sync reveals differences althouth models were not touched

Available in ERwin 4.0 Service Pack 1








Solution#: 89  COLUMN DEFAULTS NOT UNIQUELY NAMED ON FORWARD ENGINEERING


When assigning one default to two or more columns in ERwin 4.0. you get an
error when generating the code as even though you have assigned DEFAULT and
Unique Naming Count to the constraint it will not change the name in the
script.  Multiple contraints are generated with the same name.

Available in ERwin 4.0 Service Pack 1








Solution#: 90  C DIFFERENCES CHANGE WHEN GOING BACK AND RESTARTING


Doing a Complete Compare to a database, customer noticed that
that Stored Procedures and Tables (may be more object types) are not
listed twice in the list.  This occurs after performing Complete Compare
and getting the differences dialog, then hitting the back button in the
wizard until getting to the beginning, then going thru process again
without changing any options.

Available in ERwin 4.0 Service Pack 1








Solution#: 91  FUNCTION BASED INDEXES NOT REVERSE ENGINEERED FROM ORACLE


RE from Oracle and is having problems with function based indexes.
When he REs from Oracle, ERwin did not pick up the fxbased indexes and
created 2 additional columns.
If Erwin does not support function based indexes, these should
be filtered out as well.

Available in ERwin 4.0 Service Pack 1








Solution#: 92  INFER RELATIONSHIPS ON RE FROM SCRIPT NOT WORKING


I put a schema file into ( with 7 tables along with associated indexes )erwin
thru reverse engineer and the tables appear in the view, but the lines
showing the conectivity between the tables are not there.

Available in ERwin 4.0 Service Pack 1








Solution#: 93  GPF SAVING AS 3.5.2 FILE


Customer is using eval copy of 4.0.  Working with a client that has 3.5.2.
She opens a model that was originally created in 3.5.2 in 4.0 and makes
some changes like adding and dropping enitities and attributes, and had not
done anything that is a 4.0 only feature.
Attempting to save her 4.0 model as a 3.5.2 model, it crashes.

Available in ERwin 4.0 Service Pack 1








Solution#: 94  GPF OPENING 3.5.2 MODEL FOR ORACLE DATABASE


Opening 3.5.2 version model for Oracle in ERwin 4.0, received APplication
error in MMOPN32.exe

Problem occurs reading physical object information

Available in ERwin 4.0 Service Pack 1








Solution#: 95  INFER PRIMARY KEYS NOT GENERATING KEY FOR DB2/390


Infer is not working.  It asks him if he wants to infer primary keys, but
does not end up with a primary key.  Using DB2/390 version 5.
Problem was duplicated with a DDL Script, as well as from the database itself.
The customer has provided the DDL Script.  To recreate RE the Script, choose
DB2 and DB2/390 5, and check the "Primary Keys" box, under infer.

Available in ERwin 4.0 Service Pack 1








Solution#: 97  CC REPORTS INVALID DIFFERENCE IN SQL SERVER STORED PROCS


Complete Compare with database level for SQL Server.  Stored procedures
show as different when they are the same.

Available in ERwin 4.0 Service Pack 1








Solution#: 98  BITMAP INDEX NOT GENERATED FOR ORACLE DATABASE


Creating an index for ORacle and selecting BITMAP, forward engineering does
not generate SQL to create a bitmap index.

Available in ERwin 4.0 Service Pack 1








Solution#: 99  SAVE AS XML HANGS ON LARGE MODELS


XML exportis hanging when a large model (500 tables) is expoted.
ERwin is left running overnight with no success.

Available in ERwin 4.0 Service Pack 1








Solution#: 100  CC NOT RETRIEVING DB2 TABLES BASED ON SPECIFIED OWNERS


When using Complete Compare, Erwin uses the userid from the connection panel
as the owner of the database objects, ignoring the specification of the owne
in the FILTER OTHER OBJECTS panel. This prevents the compare from providing
any usefule data.

In the items to compare dialog, if compare table/views by specific owners
are specified, they are not used in the generated SQL when retrieving table
information from the database.

Available in ERwin 4.0 Service Pack 1








Solution#: 101  DDL NOT CREATED TO GENERATE FK CONSTRAINTS ON FE


Attempting to add foreign key constraints to a database using forward
engineering does not generate SQL statements to create the foreign keys.

This occurs when reverse engineering a DDL script containing only table
definitions.  Manually add primary keys to tables, then create relationships
and in the relationship editor rename the foreign key constraint name.
Select forward engineering/Schema generation, only check Referential
Integrity and Other Options/Constraint Names boxes.  Selecting preview
will not give the statements to generate the foreign keys.

Available in ERwin 4.0 Service Pack 1








Solution#: 102  SYNC WITH MODEL SOURCE NOT SHOWING COLUMN ORDER DIFFERENCES


Column order differences are not detected by Sync With Model Source.  The
model was created by the source model and using "Save as New Model".  The
source model was then added into the newly created model.  Changing column
order of a table is not detected in the Sync with Model Source process.

Available in ERwin 4.0 Service Pack 1








Solution#: 103  FK INDEX NAMES CHANGED TO DEFAULT NAME OPENING 3.5.2 MODEL


Foreign key index names are changing to default names, after customer
renamed the index.  3.5.2 file is created with 2 tables, one relationship.
Rename the foreign key index, save file and open the model in 4.0.  the
foreign key index name resets to the default name.

Available in ERwin 4.0 Service Pack 1








Solution#: 104  INORRECT DIFFERENCES SHOWN BY CC FOR ORACLE 8.1.X


After forward engineer to Oracle 8.1.7, using comments, complete compare
will show differences on the table and column comments.  Checking with
the database, they match what is in the model.

Invalid differences are also shown for table checks, domain parents and
synonyms.

Available in ERwin 4.0 Service Pack 1








Solution#: 105  CC WITH DB NOT DETECTING COL RENAME IN MODEL FROM RE


Creating an Oracle 8.x model from the Reverse Engineer process and then
changing a column name will cause COmplete COmpare not to detect that the
name was changed.  It does not match up the columns, it treats as a new
column.  In ERwin 3.5.2, the columns would be matched.

THis is true only for a model created from Reverse Engineering.  Also,
opening the 3.5.2 model in ERwin 4.0 will not cause the columns to be
matched either.

Available in ERwin 4.0 Service Pack 1








Solution#: 107  EXPORT OF COLUMN NAME CHANGE NOT GENERATING DDL


Attempt to export a column name change to database after Complete Compare.
No DDL script is generated to rename the column in the database.

Available in ERwin 4.0 Service Pack 1








Solution#: 108  EXPORT OF COLUMN NAME CHANGE NOT GENERATING DDL


Attempt to export a column name change to database after Complete Compare.
No DDL script is generated to rename the column in the database.

Available in ERwin 4.0 Service Pack 1








Solution#: 109  RELATIONSHIP NAME LOST ON DERIVE/ADD MODEL SOURCE


Deriving a physical model from a logical model or adding a logical model as
a source to a physical model will lose relationship names.  The verb phrase
is not carried into the physical model, the name reverts back to the
original generated name.

Available in ERwin 4.0 Service Pack 1








Solution#: 110  RELATIONSHIP NAME LOST ON DERIVE/ADD MODEL SOURCE


Deriving a physical model from a logical model or adding a logical model as
a source to a physical model will lose relationship names.  The verb phrase
is not carried into the physical model, the name reverts back to the
original generated name.

Available in ERwin 4.0 Service Pack 1








Solution#: 111  GPF SAVING MODEL AS 3.5.2 USING ODBC/GENERIC DB


Creating a 4.0 model and saving it as a 3.5.2 model causes a Dr. Watson
error.  Using ODBC/Generic database.

Available in ERwin 4.0 Service Pack 1








Solution#: 112  FE FOR ORACLE GENERATING CACHE OPTION WHEN NOT SELECTED


Forward engineering to Oracle 8.x. Has Physical Storage checked with
table in FE-Schema Generation, but doesn't have Cache checked in Table
Properties, Physical Property.   The CACHE parameter is being generated
for the table creation though it is not selected.

Available in ERwin 4.0 Service Pack 1








Solution#: 113  ORACLE 8I PHYSICAL PROPERTY VALUES NOT RETRIEVED BY CC


Complete compare of model with Oracle 8i database.  Physical property values
are not displayed on the database side so they are reported as differences
by Complete Compare.  It is detecting that the physical properties are there
it is just not retrieving the value of the property.

This also occurs for sequence information

Available in ERwin 4.0 Service Pack 1








Solution#: 114  UNABLE TO CHANGE KEYGROUP TO INDEX NAME MAPPING


Unable to change the default index names generated by ERwin.  The Name
Mapping option for Key Group to Index is not being accepted.
Also, there is no name mapping option for index names in a physical only
model

Available in ERwin 4.0 Service Pack 1








Solution#: 115  PARSE ERROR ON DB2 SCRIPT FOR PIECESIZE PARAMETER


Trying to RE from a script file in DB2 and is getting an error-unable to
parse "g" of line.  This occurs when parsing the PIECESIZE parameter for
an index.  Spaces are allowed between the number and qualifier (eg. 2 G or
4 M)

Available in ERwin 4.0 Service Pack 1








Solution#: 116  CC SHOWS DIFFERENCE ON USER DEFINED COLUMN DEFAULTS


Erwin v4.0 b1338, Oracle 8.1.6.  Trying to complete compare model with
the database.  Columns that use user defined default values are showing
as differences.  The default name on the database side is not matching the
name on the model side.

Available in ERwin 4.0 Service Pack 1








Solution#: 117  DIAGRAM DISPLAY CHANGES AFTER SELECTING PRINT


Open model, select fit model from toolbar.   Select Print, notice that the
tables have moved and are resized in the diagram.  In some cases tables now
overlap where they did not before.  Problem is more noticable on lower
display resolutions (800 x 600).

Available in ERwin 4.0 Service Pack 1








Solution#: 118  GPF GENERATING SCHEMA FOR DB2/390


Attempting to generate a DDL script for DB2/390 from a ERwin 3.5.2 file
opened in ERwin 4.0 results in a Dr. Watson GPF.  It fails on a CREATE
TABLESPACE command, which is the last statement in the script created.

Available in ERwin 4.0 Service Pack 1








Solution#: 119  EXPORTING COL ORDER CHANGE TO ORACLE DOES NOT GENERATE DDL


Attempting to export column order changes to database after complete
compare is not generating DDL for the order change.  THe model is using
physical order display and complete compare does detect the order change.

Available in ERwin 4.0 Service Pack 1








Solution#: 123  GPF ON SAVE AS ERX USING SYBASE MODEL FROM ERWIN 4.0


Reverse engineering SYBASE database into ERwin 4.0.  Save the model as
ERwin 3.5.2 format, then attempt to create ERX file using ERwin 3.5.2.
On the save, Dr. Watson GPF occurs, Memory could not be read.

Available in ERwin 4.0 Service Pack 1








Solution#: 124  SUBTYPE KEYS LOST ON SAVE AS 3.5.2 OPENING 3.5.2 MODEL


Primary and Foreign keys are lost for subtype relationships when saving
as ERwin 3.5.2 model.  THe original model opened is a 3.5.2 model.

Available in ERwin 4.0 Service Pack 1








Solution#: 125  POOR PERFORMANCE ON DRAG & DROP OF COLUMNS BETWEEN TABLES


Performance on drag and drop of columns from one table to another is poor.
Model has hundreds of domains, moving 1 column is slow and CPU goes up to
99% utilization for ERwin.

Available in ERwin 4.0 Service Pack 1








Solution#: 126  CC OF MODEL SAVED AS 3.5.2 GIVES PROPERTY NOT DEFINED ERROR


Open ERwin 3.5.2 Oracle model in ERwin 4.0 and save as ERwin 3.5.2.  When
performing Complete Compare using ERwin 3.5.2 model, get multiple errors
Internal Error - Physical Property " not defined.

Available in ERwin 4.0 Service Pack 1








Solution#: 127  GPF REOPENING MODEL AFTER SAVE AS 3.5.2


Open ERwin 3.5.2 model with ERwin 4.0.  After making changes to the model
save as ERwin 3.5.2 model.  Attempt to open with ERwin 4.0 again and
an application error occurs.

Available in ERwin 4.0 Service Pack 1








Solution#: 128  UNABLE TO SAVE ENTITY/TABLE COMMENT CHANGES FROM DATA BROWSE


Unable to save changes to comments for Tables or Entities from Data Browser
report.  An error message "Couldn't find Couldn't find %s" is received.

Available in ERwin 4.0 Service Pack 1








Solution#: 129 GPF OPENING LARGE 3.5.2 MODELS CREATED FROM RE ON AS/400


GPF FOR opening ERwin 3.5.2 model created by reverse engineering from
AS/400 database.  THe GPF appears to occur with large models, as if the
model is reduced using ERwin 3.5.2, it is able to be opened with ERwin 4.0

Available in ERwin 4.0 Service Pack 1








Solution#: 130  CC MODEL TO MODEL NOT DETECTING DIFFERENCES


Using complete compare to compare the current open model with modifications
made to the original model does not detect differences.  Expanding the
resolve differences dialog unchecking the show only differences box will
show the right side has the same values as the left side which was changed.

Available in ERwin 4.0 Service Pack 1








Solution#: 131  CARDINALITY DISPLAYS FOR SUBTYPE RELATIONSHIP IN IDEF1X


Subtype relationships are displaying the "Z" cardinality both near the symbol
and by the child tables.  This is not IDEF1X standard.

Available in ERwin 4.0 Service Pack 1








Solution#: 132  GPF IN MODEL EXPLORER SELECTING PHYS PROPERTIES FOR TABLE


Exception error in model explorer after reverse engineering a DB2 UDB 6.1
script.  Right click on Tables, select properties.  Select a table from the
table editor then select the Physical Propertied tab.  This will cause
ERwin to crash.

Available in ERwin 4.0 Service Pack 1








Solution#: 134  NOT ALL TABLES RETURNED FROM DB ON COMPLETE COMPARE


Running complete compare, the resolve differences dialog does not show
all tables from the database.  Reverse engineer will bring in all tables.
It appears that the query complete compare uses is based on userid while
reverse engineer is on ownerid.

THe problem occurs when the schema/owner names specified in the wizard
is not the same as the userid that is connecting to the database

Available in ERwin 4.0 Service Pack 1








Solution#: 135  RELATIONSHIP LINES NOT ATTACHED TO ENTITIES


Relationship lines exist that are not attached to entities.  Selecting the
relationship line and using Auto Layout will correct the display, but later
on the line becomes disconnected again.

Available in ERwin 4.0 Service Pack 1








Solution#: 136  SUBTYPE RELATIONSHIP MODIFIED ON OPEN OF 3.5.2 MODEL


An exclusive subtype relationship existing in a ERwin 3.5.2 model is
modified when opened in ERwin 4.0.  The logical side is fine, the physical
side shows a 0, 1 or more relationship instead of a 0 or 1 relationship.
The relationship displays as identifying instead of as a subtype.

Available in ERwin 4.0 Service Pack 1








Solution#: 137  EXPORTING CHANGES AFTER COMPLETE COMPARE NOT GENERATING DDL


Complete compare, exporting change to create a primary key on a table.
No DDL is generated to add a primary key to the table, just a comment is
generated stating NO ACTION.

Exporting changes to physical properties also do not generate DDL.
Examples are PCTFREE and APPEND for table properties.

Exporting column datatype changes also do not generate DDL.

Exporting column comments and NULL option also is not generating DDL

Available in ERwin 4.0 Service Pack 1








Solution#: 138  FE FOR DB2 VIEW NOT CLOSING SQL STATEMENT WITH ;


Forward engineering for DB2 design is building view definitions without
closing the SQL statement with a semi-colon.  This causes a syntax error
generating the view.

Available in ERwin 4.0 Service Pack 1








Solution#: 139  REVERSE ENGINEER NOT RETRIEVING ORACLE SEQUENCES


On reverse engineering for Oracle sequences, ERwin is querying the
USER_SEQUENCE Oracle system table instead of the ALL_SEQUENCE view.

Available in ERwin 4.0 Service Pack 1








Solution#: 140  %TABLENAME MACRO NOT EXPANDING FOR INDEX NAME


%TableName macro does not expand in index name macro %TableNameX%KeyType

Available in ERwin 4.0 Service Pack 1








Solution#: 141  INDEXES DISAPPEAR AFTER SAVING MODEL CONVERTED FROM 3.5.2


Create model in erwin 3.5.2 and open it in 4.0. Saving the model as ERwin
4.0 will cause indexes to disappear when the model is reopened in ERwin 4.0

Available in ERwin 4.0 Service Pack 1








Solution#: 142  RI ACTIONS LOST AFTER SPLIT OF 3.5.2 MODEL


RI Action settings for relationships are lost when splitting a ERwin 3.5.2
model.  THe actions are retained when opening the 3.5.2 model in 4.0, but
are lost in the split models.

Available in ERwin 4.0 Service Pack 1








Solution#: 143  COMPLETE COMPARE COMPARING OBJECT NOT SELECTED FOR COMPARE


Complete compare is comparing column datatypes even though it is not
selected in the option set for columns.  The model side shows ---- for the
datatype while the database side is showing the datatype.

Other options include column order, NULL, FILEGROUP, index member position
and domains

Available in ERwin 4.0 Service Pack 1








Solution#: 145  FK CONSTRAINT NAME LOST ON SPLIT OF 3.5.2 MODEL


Splitting a ERwin 3.5.2 model in ERwin 4.0 will cause foreign key constraint
names to be lost in the physical model.  Both the logical model and the
opened logical/physical model contain the constraint name.

Available in ERwin 4.0 Service Pack 1








Solution#: 146  COPY/PASTE OF ENTITY FROM MODEL CHANGES DATATYPE OF COLUMNS


Datatypes of columns are changed when copy/paste from one model into
another model.  The affected columns are created from domains.  For
example, SQL Server 7.0 domain using decimal(10) as a datatype, when
copy/paste in executed, is converted into smallmoney in the new model.

Also, for DB2 UDB, Varchar with length drops the length.

Available in ERwin 4.0 Service Pack 1








Solution#: 147  PERFORMANCE ON SAVE FROM WIN2000 TO NT NETWORK DRIVE


Performance for file save from Windows 2000 to a Windows NT network drive
is much slower than saving from Windows NT to a Windows NT network drive.

Available in ERwin 4.0 Service Pack 1








Solution#: 148  REVERSE ENGINEER NOT DETECTING ORACLE BITMAP INDEX


Oracle bitmap index is not detected by reverse engineering.

Available in ERwin 4.0 Service Pack 1








Solution#: 149  GPF ON SPLIT OF 3.5.2 MODEL


Attempting to split a ERwin 3.5.2 model will GPF after getting the dialog
box to name the logical model.

Available in ERwin 4.0 Service Pack 1








Solution#: 150  GPF IN DATA BROWSER LISTING DATASOURCE NAMES 

Trying to run a report to list the data source names and transform
comments in a dimensional model, ERWin crashes with a GPF.  This occurs
with both converted ERwin 3.5.2 models and new models built in ERwin 4.0.

Available in ERwin 4.0 Service Pack 1








Solution#:  151  LINK WITH MODEL SOURCE LOST AFTER SYNCHRONIZE UPDATE SOURCE


The link between a derived model and its source model is lost after only
one Sync. When you again Sync with the source model none of the tables are
matched.  The first sync updated the source model with a change from the
derived model.

Available in ERwin 4.0 Service Pack 1









Solution#: 152  FK LOGICAL ONLY ATTRIBUTE REMOVED WHEN PARENT ATT CHANGED


Setting a foreign key attribute as logical only and modifying the parent
column on the physical side of a model will remove the logical only setting
on the foreign key attribute.

Available in ERwin 4.0 Service Pack 1








Solution#: 153  RI TRIGGER FOR SQL SERVER 2000 FAILS ON FE


Syntax error on forward engineer to SQL Server 2000 for an ERwin override
RI Trigger on table insert.  An invalid WHERE clause is generated.

Available in ERwin 4.0 Service Pack 1








Solution#: 154  GPF ON DERIVE LOGICAL MODEL FROM ERWIN 3.5.2 MODEL


Deriving a logical model from an ERwin 3.5.2 model will cause a GPF.

Available in ERwin 4.0 Service Pack 1









Solution#: 156  USER DEFINED DATATYPES NOT USED FOR COLUMNS BY FE


When using user defined datatypes for SQL Server, forward engineer will
create the datatype, but when defining columns using these types, ERwin
does not use the datatype but the definition of the datatype.

Available in ERwin 4.0 Service Pack 1








Solution#: 157  POSSIBLE FILE ERROR OPENING MODEL SAVED AS 3.5.2 IN 3.5.2


Create file in ERwin 4.0 and save it as ERwin 3.5.2.  When opened in ERwin
3.5.2 receive messages about Possible FIle Error Fixed, Contact Computer
Associates.

Available in ERwin 4.0 Service Pack 1








Solution#: 158  SYNC MODEL SOURCE NOT MATCHING TRANSFORMS


Sync with model source is not detecting matches between the model and the
source model.  THis occurs when creating a physical model using a logical
model as the source model.

Available in ERwin 4.0 Service Pack 1








Solution#: 159  COMPLETE COMPARE REPORTS DIFFERENCES AFTER IMPORTING CHANGES


When specifying that Complete Compare differences should be imported from
DDL into the model, on the 2nd compare there are still differences displayed
using the same options.  This seems to continue for subsequent compares
after importing differences.

Available in ERwin 4.0 Service Pack 1








Solution#: 160  GPF ON RE OF SYBASE SCRIPT CONTAINING GRANT CLAUSE


Reverse engineer of SYBASE 11.x script will cause ERwin to hang, then
crash with GPF at a GRANT clause.

Available in ERwin 4.0 Service Pack 1








Solution#: 161  ROLENAMES AND PK LOST ON TABLE WITH CYCLIC RELATIONSHIP


Converting a ERwin 3.5.2 model to ERwin 4.0.  After conversion, going into
the index or column editors will cause rolenamed attributes to be lost for
a self-referencing (cyclic) relationship.  Also, the primary key no longer
will show in the index editor for that table.

Available in ERwin 4.0 Service Pack 1








Solution#: 162  GPF ON OPEN OF 3.5.2 MODEL CREATED FROM SUBJECT AREA


Opening of a ERwin 3.5.2 file created from a subject area in ModelMart
crashes when opened in ERwin 4.0.

Available in ERwin 4.0 Service Pack 1








Solution#: 163  DEFAULT VALUES NOT SEEN BY COMPLETE COMPARE


Complete Compare not seeing Database Default Values, so they are appearing
as differences.

Available in ERwin 4.0 Service Pack 1








Solution#: 164  RE OF SQL SERVER NOT RETRIEVING INDEX FILEGROUP INFO


Reverse Engineer does retrieve the Index Filegroup information for SQL
Server, but Complete Compare does.

Available in ERwin 4.0 Service Pack 1








Solution#: 165  LOOP THEN GPF ON RE OF SQL SERVER SCRIPT WITH VIEWS


Reverse Engineer of SQL Server script with views hangs on a SET statement
then crashes.

Available in ERwin 4.0 Service Pack 1








Solution#: 167  NULL OPTION NOT SHOWN PROPERLY BY COMPLETE COMPARE


Null Option is incorrect in Complete Compare with SQL Server 2000.
Customer Reverse Engineered a SQL Server 2000 Database and then immediately
did a Complete Compare with the Database.  The database side shows values
of 1 or 0 for the NULL option.

Null option also occasionally shows as -1 or 8 or other number

Also occurs for other databases as well.  This also affects the change
script when exporting/importing changes.

Available in ERwin 4.0 Service Pack 1








Solution#: 168  UNABLE TO IMPORT ERX FILE INTO 3.5.2


Unable to import ERX file back into ERwin 3.5.2.  THe model was opened in
ERwin 4.0, saved as ERwin 3.5.2 format and ERX file created from the new
file.

Available in ERwin 4.0 Service Pack 1








Solution#: 169  REL NOT GENERATED IN DDL WHEN THERE IS LOGICAL ONLY ATT


ALTER TABLE ADD FOREIGN KEY statement is not generated when one of the
migrated attributes for the relationship is marked as logical only in the
child table.

Available in ERwin 4.0 Service Pack 1








Solution#: 170  SET IDENTITY NOT GENERATING EXPORTING FROM CC


Set identity does not get generated in DDL when exporting from Complete
Compare.  THis occurs when making modifications to a table containing an
identity field.  Exporting changes from complete compare forces a drop and
recreate of the table, SET IDENTITY ON/OFF is not generated.

Available in ERwin 4.0 Service Pack 1








Solution#: 171  COMPLETE COMPARE SHOWING INVALID DIFFERENCES FOR SQL SERVER


Complete compare for SQL Server between model and database reports
differences that do not exist.  The differences occur in physical properties
and indexes.

Other objects as well report invalid differences

Available in ERwin 4.0 Service Pack 1








Solution#: 172 GPF SELECTING NAMING STANDARDS FILE


MMopn32.exe error with Naming file.
Open a new or existing model, Go tools, Names, Model Naming Options, Choose
"use file", select and open file.  Click okay and Erwin crashes.

Available in ERwin 4.0 Service Pack 1








Solution#: 173  OPTION SET NOT SAVED FOR COMPLETE COMPARE


Changes to the default option set for complete compare are not saved.

Creation of option set not saving settings, all options are selected when
opening option set created for COmplete Compare for DBSYNC








Solution#: 174  INVALID DDL GENERATED FOR EXPORT AFTER COMPLETE COMPARE


Exporting or previewing changes after complete compare for SQL Server
creates a "drop synonym 1" statement always.  This is not a valid statement
for SQL Server.

Available in ERwin 4.0 Service Pack 1








Solution#: 175  ATTRIBUTE EDITOR NOT REFLECTING CASE OPTION


Attribute Editor is not reflecting lowercase value from Model Naming Option,
but Explorer and digaram does. This works fine in Physical side for Column
Editor.

Available in ERwin 4.0 Service Pack 1








Solution#: 176  ORACLE PHYS STOR PARMS NOT GENERATED BY FE FOR NON-PK INDEX


Physical storage paramaters not generated for non-Primary Key Oracle
indexes.

Available in ERwin 4.0 Service Pack 1








Solution#: 178  MISSING GO STATEMENT ON FE FOR SQL SERVER MODELS


Missing "GO" statements when generating create view script from an SQL
Server 7 physical model.

Available in ERwin 4.0 Service Pack 1








Solution#: 179  ATT NAMES 'UNKNOWN' IMPORTING ERX FILE


Importing an ERX file generated from an ERwin 4.0 model saved as 3.5.2 will
give invalid attribute/column names.  Attribute names are <unknown>, column
names as '_unknown_'.

Available in ERwin 4.0 Service Pack 1








Solution#: 180  GENERATED SCRIPT FOR FORWARD ENGINEERING IS TRUNCATED


For a DB2/390 v5 design, forward engineering is truncating the script.
Not all objects in the design are being created.  There is no pattern.

Available in ERwin 4.0 Service Pack 1








Solution#: 181  BUFFERPOOL OPTION GENERATED FOR ORACLE WHEN NOT SELECTED


Once the buffer_pool checkbox has been turned on for a table and
OK clicked, it cannot be turned off and will continue to generate.
Reopening the table properties dialog and unchecking it will appear to turn
it off, but once you click OK and reopen the dialog, the box is still
checked.

Available in ERwin 4.0 Service Pack 1








Solution#: 182  GPF OPENING 3.5.2 DIMENSIONAL MODEL


GPF may occur opening an ERwin 3.5.2 dimensional model.

Available in ERwin 4.0 Service Pack 1








Solution#: 183  ALTERNATE KEY NAME INCORRECT IN DISPLAY


Add an alternate key to a table with a single column and it shows up in
the display as (AK1,2).  It should show as (AK1,1).

Adding a second column to the key shows up as (AK1,3),
although I would expect it to be (AK1,2).

Available in ERwin 4.0 Service Pack 1








Solution#: 184  DB2/390 DOMAIN BLOB DATATYPE GENERATED INCORRECTLY BY FE


When creating a new DB2/390 v5 or v4 design, ERwin establishes the datatype
of domain Blob sometimes correctly as LONGVARGRAPHIC and sometimes
incorrectly as BLOB.  BLOB is valid and appropriate only for DB2 V6.

It is generated incorrectly in a logical/physical model.

Available in ERwin 4.0 Service Pack 1








Solution#: 185  ATTRIBUTE NOT REMOVED FROM DIAGRAM WHEN DELETED FROM ME


Deleting an attribute/column from Model Explorer does not remove them from
the diagram.  On logical side, deleting attribute that is migrated to a
child table is not deleted in the child table.  On the physical side, the
column is not deleted from either owner table or child table.

Available in ERwin 4.0 Service Pack 1








Solution#: 186  OWNER NOT DISPLAYED IN S/A EDITOR


owner not displayed in Subject Area "Members Editor" when Table Display
option Owner selected.

Available in ERwin 4.0 Service Pack 1








Solution#: 187  COMPLETE COMPARE WITH DB - IMPORT NOT CREATING NEW COLUMNS


Complete Compare with a database, new columns do not get imported into the
model.  Compare and import from another model will import new columns.

Available in ERwin 4.0 Service Pack 1








Solution#: 189  DEFAULT FONTS/COLORS ENTITY BOX FILL CHANGE NOT APPLYING


Changing the Box Fill Colour for a diagram (context menu on empty diagram,
Option "Default Fonts&Colours", Box Fill Colour) does not have any effect, no
matter if you choose the current objects, new objects or all objects option.
Although 'saving' that colour option the setting does not apply, it will be
reset after leaving and re-entering the 'Default Fonts&Colours" Option again.

Available in ERwin 4.0 Service Pack 1








Solution#: 190  RENAME OF ATT AFTER COPY/PASTE DOES NOT CHANGE COL NAME


Copy/Paste of an entity in a logical/physical model.  Rename an attribute
in the new entity, switch to the physical side and see that the column
retains the original name of the attribute instead of inheriting the logical
name.

Available in ERwin 4.0 Service Pack 1








Solution#: 191  SYNC MODEL SOURCE NOT IMPORTING/EXPORTING ALL INFO


Not all information is being imported/exported during a Sync with Model
Source.  Some columns and relationships are not migrated.

Problem also occurs with domains.

Available in ERwin 4.0 Service Pack 1








Solution#: 192  SYNC MODEL SOURCE NOT MATCHING OBJECTS PROPERLY


Sync with Model Source is not always matching objects between a physical
model and its logical source model.

Available in ERwin 4.0 Service Pack 1








Solution#: 193  UNABLE TO DELETE ORACLE TABLE PARTITIONS FROM EXPLORER


Unable to delete Oracle table partitions using the Model Explorer.

Available in ERwin 4.0 Service Pack 1








Solution#: 194  DUPLICATE ATTRIBUTE CREATED IN GRANDCHILD TABLE


Duplicate primary key attributes appear in a grandchild table.  This occurs
when the parent table inherits the same attribute name from 2 tables.  The
parent table does not have duplicate attributes.

Available in ERwin 4.0 Service Pack 1








Solution#: 195  DBSYNC NOT INVOKING CC ON SQL SERVER FILEGROUP EDITOR


Invoking DB SYNC from the SQL Server Filegroup Editor is not invoking the
synchronization.  THe complete compare dialogs should be invoked.

Available in ERwin 4.0 Service Pack 1








Solution#: 196  UNABLE TO REPLACE CA LOGO IN RTB GENERATED REPORT


There is no ability to change the logo used by RTB in generating HTML
reports.

Available in ERwin 4.0 Service Pack 1








Solution#: 197  WRAP TEXT OUTPUT IN RTB GENERATED HTML REPORTS


Provide ability for wrapping text output in HTML reports generated by the
Report Template Builder.

Available in ERwin 4.0 Service Pack 1








Solution#: 198  UDP VALUES LOST SAVING MODEL AS 3.5.2


Saving an ERwin 4.0 model as 3.5.2 format will lose UDP values that are
created for the Domain Dictionary.

Available in ERwin 4.0 Service Pack 1








Solution#: 199  ER1 FILES CREATED BY SP1 CAN NOT BE OPENED BY OLD VERSIONS


ERwin 4.0 Service Pack 1 has made changes to the file format of the er1
files.  Because of these changes, models saved using Service Pack 1
will not open in older versions of ERwin 4.0.

It is therefore required that all users upgrade to Service Pack 1 in
order to be able to share models saved using the Service Pack.

Attempting to open an er1 file created with Service Pack 1 in older
versions of ERwin 4.0 will result in a hang condition with blank menu
items on the ERwin window.








Solution#: 200  MODEL LEVEL CC NOT COMPARING ALL PHYSICAL PROPERTIES


Complete compare of 2 models with a model level, physical compare is not
comparing all database physical properties of the model.  An example of this
is filegroup for SQL Server 2000.

This occurs by design for Model Level Compares, which is intended to compare
only the physical properties of the model (physical side) and not the
actual database physical properties.

This level of comparision can be made using the database level compare
between two models.  This will compare the physical database properties
described in the physical model.






Solution#: 201  FK COLUMNS NOT DELETED FROM CHILD ON RELATIONSHIP DELETE

Deleting a non-identifying relationship in a model converted from ERwin      
3.5.2 will leave some foreign key columns in the child table.  The columns   
can not be deleted by the column editor or through model explorer.           
                                                                             
This problem was a result of problem with conversion of ERwin 3.5.2 models   
into ERwin 4.0 GA build 1298 and Patch 1 build 1338.  The result was that    
the parent attribute for the Foreign Key was incorrect in that all foreign   
key attributes for a relationship all have the same parent attribute in the  
parent table.                                                                
                                                                             
ERwin 4.0 Service Pack 1 has corrected this problem and converting of        
ERwin 3.5.2 models using this build will not have this problem.  This        
build will also detect this condition in existing models and attempt to      
correct the problem.  In some instances it may not be possible for ERwin     
to correctly determine the parent attribute for a foreign key attribute,     
and a report will be generated to list these attributes that could not be    
corrected.
